package com.dwxt.sport.business.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonInclude;
import lombok.Data;
import lombok.experimental.Accessors;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.time.LocalDateTime;

@Data
@Accessors(chain = true)
@JsonInclude(JsonInclude.Include.NON_NULL)
@Table(name = "t_quinquagenarian_sports_health")
public class QuinquagenarianSportsHealth {

    @Id
    private String id;

    /**
     * 街道id
     */
    @Column(name = "street_id")
    private String streetId;

    /**
     * 设备名称
     */
    private String name;

    /**
     * 设备型号
     */
    @Column(name = "unit_type")
    private String unitType;

    /**
     * 设备图片地址
     */
    @Column(name = "equipments_img_url")
    private String equipmentsImgUrl;

    /**
     * 设备数量(关联设备数据之和)
     */
    private Integer amount;

    /**
     * 总人次
     */
    @Column(name = "total_person_times")
    private Integer totalPersonTimes;

    /**
     * 平均使用时间
     */
    @Column(name = "avg_elapsed_time")
    private Double avg;

    /**
     * 建设覆盖率
     */
    @Column(name = "construction_coverage")
    private String constructionCoverage;

    /**
     * 建议覆盖率
     */
    @Column(name = "recommended_coverage")
    private String recommendedCoverage;

    /**
     * 逻辑删除标识(0否1是)
     */
    @Column(name = "is_delete")
    private String isDelete;

    /**
     * 创建时间
     */
    @Column(name = "create_time")
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private LocalDateTime createTime;

    /**
     * 创建人id
     */
    @Column(name = "create_user_id")
    private String createUserId;

    /**
     * (最近)更新时间
     */
    @Column(name = "update_time")
    @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
    private LocalDateTime updateTime;

    /**
     * 更新人id
     */
    @Column(name = "update_user_id")
    private String updateUserId;

    /**
     * 备用字段1
     */
    private String attr1;

    /**
     * 备用字段2
     */
    private String attr2;

    /**
     * 备用字段3
     */
    private String attr3;

    /**
     * 备用字段4
     */
    private String attr4;

}